
/*Project: 		The Impact of Short-Term Employment for Low-Income Youth: Experimental 	
				Evidence from the Philippines
Authors: 		Emily A. Beam and Stella Quimbo

***********************************
Path: 			code/02_analysis
File name: 		table_a04.do 
***********************************

Purpose: 		Generates Appendix Table A04 (column 2) Note that column 1 generated from BLE (2017)

Inputs: 		spes_data.dta
Outputs: 		log_table_a04.log (table generated manually)

Log: 			results/03_output/log_table_a04.log		

Last updated: 	18 November 2021
*/ 


cap log close 
log using "$output/log_table_a04.log",replace



use "$usedata_analysis/spes_data",clear

 
 * Share female, study sample 
 tab _bb_female
 
 
 * Age distribution 
 gen _agecat = . 
	replace _agecat = 1 if _bb_age >=15 & _bb_age <=18
	replace _agecat = 2 if _bb_age >=19 & _bb_age <=21
	replace _agecat = 3 if _bb_age >=22 & _bb_age <=25
	

lab def agecat 1 "age 15-18" 2 "age 19-21" 3 "age 22-25"
lab val _agecat agecat
tab _agecat
	
* Previous SPES participants
tab _bb_spesbaby		

* SPES program duration 
gen _nodays_cat = . 
	replace _nodays_cat = 1 if _nodays == 20
	replace _nodays_cat = 2 if _nodays >=21 & _nodays <=30
	replace _nodays_cat = 3 if _nodays >=31 & _nodays <=51
	replace _nodays_cat = 4 if _nodays == 52
	

lab def nodays 1 "20 days" 2 "21-30 days" 3 "31-51 days" 4 "52 days"

lab val _nodays_cat nodays

tab _nodays_cat

* SPES employer type 
tab _eeo_spes_privemp


log close 

exit 
